Dataset statistics
| Number of variables | 27 |
|---|---|
| Number of observations | 108785 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 75.2 MiB |
| Average record size in memory | 725.3 B |
Variable types
| NUM | 16 |
|---|---|
| CAT | 9 |
| BOOL | 2 |
Reproduction
| Analysis started | 2020-05-05 06:15:53.588805 |
|---|---|
| Analysis finished | 2020-05-05 06:18:58.309917 |
| Version | pandas-profiling v2.6.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
country has a high cardinality: 173 distinct values | High cardinality |
arrival_date has a high cardinality: 730 distinct values | High cardinality |
babies is highly skewed (γ1 = 25.60230831) | Skewed |
previous_cancellations is highly skewed (γ1 = 23.5072585) | Skewed |
previous_bookings_not_canceled is highly skewed (γ1 = 22.49048645) | Skewed |
arrival_date only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
lead_time has 5936 (5.5%) zeros | Zeros |
stays_in_weekend_nights has 48197 (44.3%) zeros | Zeros |
stays_in_week_nights has 6971 (6.4%) zeros | Zeros |
children has 101830 (93.6%) zeros | Zeros |
babies has 107951 (99.2%) zeros | Zeros |
previous_cancellations has 102366 (94.1%) zeros | Zeros |
previous_bookings_not_canceled has 105388 (96.9%) zeros | Zeros |
booking_changes has 92781 (85.3%) zeros | Zeros |
agent has 15530 (14.3%) zeros | Zeros |
company has 102214 (94.0%) zeros | Zeros |
days_in_waiting_list has 105101 (96.6%) zeros | Zeros |
adr has 1742 (1.6%) zeros | Zeros |
required_car_parking_spaces has 101966 (93.7%) zeros | Zeros |
total_of_special_requests has 65912 (60.6%) zeros | Zeros |
| Distinct count | 108785 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54393.0 |
|---|---|
| Minimum | 1 |
| Maximum | 108785 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5440.2 |
| Q1 | 27197 |
| median | 54393 |
| Q3 | 81589 |
| 95-th percentile | 103345.8 |
| Maximum | 108785 |
| Range | 108784 |
| Interquartile range (IQR) | 54392 |
Descriptive statistics
| Standard deviation | 31403.66885 |
|---|---|
| Coefficient of variation (CV) | 0.5773476156 |
| Kurtosis | -1.2 |
| Mean | 54393 |
| Median Absolute Deviation (MAD) | 27196.25 |
| Skewness | 0 |
| Sum | 5917142505 |
| Variance | 986190417.5 |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 21792 | 1 | < 0.1% | |
| 17698 | 1 | < 0.1% | |
| 19747 | 1 | < 0.1% | |
| 29988 | 1 | < 0.1% | |
| 32037 | 1 | < 0.1% | |
| 25894 | 1 | < 0.1% | |
| 27943 | 1 | < 0.1% | |
| 5416 | 1 | < 0.1% | |
| 7465 | 1 | < 0.1% | |
| Other values (108775) | 108775 | > 99.9% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 108785 | 1 | < 0.1% | |
| 108784 | 1 | < 0.1% | |
| 108783 | 1 | < 0.1% | |
| 108782 | 1 | < 0.1% | |
| 108781 | 1 | < 0.1% |
hotel
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 850.0 KiB |
| City Hotel | |
|---|---|
| Resort Hotel |
| Value | Count | Frequency (%) | |
| City Hotel | 72364 | 66.5% | |
| Resort Hotel | 36421 | 33.5% |
Length
| Max length | 12 |
|---|---|
| Mean length | 10.66959599 |
| Min length | 10 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 8 | 66.7% | |
| Uppercase_Letter | 3 | 25.0% | |
| Space_Separator | 1 | 8.3% |
| Value | Count | Frequency (%) | |
| Latin | 11 | 91.7% | |
| Common | 1 | 8.3% |
| Value | Count | Frequency (%) | |
| ASCII | 12 | 100.0% |
is_canceled
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 850.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 68460 | 62.9% | |
| 1 | 40325 | 37.1% |
| Distinct count | 464 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 100.15984740543273 |
|---|---|
| Minimum | 0 |
| Maximum | 737 |
| Zeros | 5936 |
| Zeros (%) | 5.5% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 17 |
| median | 65 |
| Q3 | 152 |
| 95-th percentile | 316 |
| Maximum | 737 |
| Range | 737 |
| Interquartile range (IQR) | 135 |
Descriptive statistics
| Standard deviation | 104.95313 |
|---|---|
| Coefficient of variation (CV) | 1.047856329 |
| Kurtosis | 1.866543146 |
| Mean | 100.1598474 |
| Median Absolute Deviation (MAD) | 82.6484831 |
| Skewness | 1.396455732 |
| Sum | 10895889 |
| Variance | 11015.1595 |
| Value | Count | Frequency (%) | |
| 0 | 5936 | 5.5% | |
| 1 | 3296 | 3.0% | |
| 2 | 1939 | 1.8% | |
| 3 | 1720 | 1.6% | |
| 4 | 1625 | 1.5% | |
| 5 | 1479 | 1.4% | |
| 6 | 1364 | 1.3% | |
| 7 | 1271 | 1.2% | |
| 8 | 1075 | 1.0% | |
| 12 | 1016 | 0.9% | |
| Other values (454) | 88064 | 81.0% |
| Value | Count | Frequency (%) | |
| 0 | 5936 | 5.5% | |
| 1 | 3296 | 3.0% | |
| 2 | 1939 | 1.8% | |
| 3 | 1720 | 1.6% | |
| 4 | 1625 | 1.5% |
| Value | Count | Frequency (%) | |
| 737 | 1 | < 0.1% | |
| 709 | 1 | < 0.1% | |
| 629 | 17 | < 0.1% | |
| 626 | 30 | < 0.1% | |
| 622 | 17 | < 0.1% |
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.9094452360159948 |
|---|---|
| Minimum | 0 |
| Maximum | 19 |
| Zeros | 48197 |
| Zeros (%) | 44.3% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 19 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 0.9925027134 |
|---|---|
| Coefficient of variation (CV) | 1.091327629 |
| Kurtosis | 7.060820167 |
| Mean | 0.909445236 |
| Median Absolute Deviation (MAD) | 0.8058561758 |
| Skewness | 1.398232453 |
| Sum | 98934 |
| Variance | 0.9850616361 |
| Value | Count | Frequency (%) | |
| 0 | 48197 | 44.3% | |
| 2 | 29599 | 27.2% | |
| 1 | 28012 | 25.7% | |
| 4 | 1605 | 1.5% | |
| 3 | 1047 | 1.0% | |
| 6 | 149 | 0.1% | |
| 5 | 72 | 0.1% | |
| 8 | 57 | 0.1% | |
| 7 | 19 | < 0.1% | |
| 9 | 9 | < 0.1% | |
| Other values (7) | 19 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 48197 | 44.3% | |
| 1 | 28012 | 25.7% | |
| 2 | 29599 | 27.2% | |
| 3 | 1047 | 1.0% | |
| 4 | 1605 | 1.5% |
| Value | Count | Frequency (%) | |
| 19 | 1 | < 0.1% | |
| 18 | 1 | < 0.1% | |
| 16 | 2 | < 0.1% | |
| 14 | 1 | < 0.1% | |
| 13 | 2 | < 0.1% |
| Distinct count | 33 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4649354230822262 |
|---|---|
| Minimum | 0 |
| Maximum | 50 |
| Zeros | 6971 |
| Zeros (%) | 6.4% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.887033616 |
|---|---|
| Coefficient of variation (CV) | 0.7655509343 |
| Kurtosis | 24.67681927 |
| Mean | 2.464935423 |
| Median Absolute Deviation (MAD) | 1.337468635 |
| Skewness | 2.933117079 |
| Sum | 268148 |
| Variance | 3.560895869 |
| Value | Count | Frequency (%) | |
| 2 | 31367 | 28.8% | |
| 1 | 27975 | 25.7% | |
| 3 | 20341 | 18.7% | |
| 5 | 9503 | 8.7% | |
| 4 | 8457 | 7.8% | |
| 0 | 6971 | 6.4% | |
| 6 | 1270 | 1.2% | |
| 10 | 921 | 0.8% | |
| 7 | 891 | 0.8% | |
| 8 | 526 | 0.5% | |
| Other values (23) | 563 | 0.5% |
| Value | Count | Frequency (%) | |
| 0 | 6971 | 6.4% | |
| 1 | 27975 | 25.7% | |
| 2 | 31367 | 28.8% | |
| 3 | 20341 | 18.7% | |
| 4 | 8457 | 7.8% |
| Value | Count | Frequency (%) | |
| 50 | 1 | < 0.1% | |
| 42 | 1 | < 0.1% | |
| 40 | 2 | < 0.1% | |
| 34 | 1 | < 0.1% | |
| 33 | 1 | < 0.1% |
adults
Real number (ℝ≥0)
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.8452635933262858 |
|---|---|
| Minimum | 0 |
| Maximum | 55 |
| Zeros | 205 |
| Zeros (%) | 0.2% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 55 |
| Range | 55 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.5824939318 |
|---|---|
| Coefficient of variation (CV) | 0.3156697688 |
| Kurtosis | 1452.599073 |
| Mean | 1.845263593 |
| Median Absolute Deviation (MAD) | 0.3483700911 |
| Skewness | 19.83475462 |
| Sum | 200737 |
| Variance | 0.3392991806 |
| Value | Count | Frequency (%) | |
| 2 | 81464 | 74.9% | |
| 1 | 21970 | 20.2% | |
| 3 | 5076 | 4.7% | |
| 0 | 205 | 0.2% | |
| 4 | 54 | < 0.1% | |
| 26 | 5 | < 0.1% | |
| 27 | 2 | < 0.1% | |
| 20 | 2 | < 0.1% | |
| 5 | 2 | < 0.1% | |
| 55 | 1 | < 0.1% | |
| Other values (4) | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 205 | 0.2% | |
| 1 | 21970 | 20.2% | |
| 2 | 81464 | 74.9% | |
| 3 | 5076 | 4.7% | |
| 4 | 54 | < 0.1% |
| Value | Count | Frequency (%) | |
| 55 | 1 | < 0.1% | |
| 50 | 1 | < 0.1% | |
| 40 | 1 | < 0.1% | |
| 27 | 2 | < 0.1% | |
| 26 | 5 | < 0.1% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.09237486785862022 |
|---|---|
| Minimum | 0.0 |
| Maximum | 10.0 |
| Zeros | 101830 |
| Zeros (%) | 93.6% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3773091009 |
|---|---|
| Coefficient of variation (CV) | 4.084542794 |
| Kurtosis | 22.19372655 |
| Mean | 0.09237486786 |
| Median Absolute Deviation (MAD) | 0.1729380483 |
| Skewness | 4.416691082 |
| Sum | 10049 |
| Variance | 0.1423621576 |
| Value | Count | Frequency (%) | |
| 0 | 101830 | 93.6% | |
| 1 | 3922 | 3.6% | |
| 2 | 2979 | 2.7% | |
| 3 | 53 | < 0.1% | |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 101830 | 93.6% | |
| 1 | 3922 | 3.6% | |
| 2 | 2979 | 2.7% | |
| 3 | 53 | < 0.1% | |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10 | 1 | < 0.1% | |
| 3 | 53 | < 0.1% | |
| 2 | 2979 | 2.7% | |
| 1 | 3922 | 3.6% | |
| 0 | 101830 | 93.6% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.007951463896676931 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros | 107951 |
| Zeros (%) | 99.2% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.09815748067 |
|---|---|
| Coefficient of variation (CV) | 12.34457981 |
| Kurtosis | 1731.883529 |
| Mean | 0.007951463897 |
| Median Absolute Deviation (MAD) | 0.01578100803 |
| Skewness | 25.60230831 |
| Sum | 865 |
| Variance | 0.009634891011 |
| Value | Count | Frequency (%) | |
| 0 | 107951 | 99.2% | |
| 1 | 818 | 0.8% | |
| 2 | 14 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 107951 | 99.2% | |
| 1 | 818 | 0.8% | |
| 2 | 14 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 2 | 14 | < 0.1% | |
| 1 | 818 | 0.8% | |
| 0 | 107951 | 99.2% |
meal
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 850.0 KiB |
| BB | |
|---|---|
| HB | 12705 |
| SC | 10238 |
| FB | 743 |
| Value | Count | Frequency (%) | |
| BB | 85099 | 78.2% | |
| HB | 12705 | 11.7% | |
| SC | 10238 | 9.4% | |
| FB | 743 | 0.7% |
Length
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 5 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 5 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 5 | 100.0% |
| Distinct count | 173 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 850.0 KiB |
| PRT | |
|---|---|
| GBR | |
| FRA | |
| ESP | 7614 |
| DEU | 6387 |
| Other values (168) |
| Value | Count | Frequency (%) | |
| PRT | 45865 | 42.2% | |
| GBR | 10764 | 9.9% | |
| FRA | 9498 | 8.7% | |
| ESP | 7614 | 7.0% | |
| DEU | 6387 | 5.9% | |
| ITA | 3407 | 3.1% | |
| IRL | 3053 | 2.8% | |
| BEL | 1992 | 1.8% | |
| BRA | 1989 | 1.8% | |
| NLD | 1910 | 1.8% | |
| Other values (163) | 16306 | 15.0% |
Length
| Max length | 7 |
|---|---|
| Mean length | 3.008080158 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 26 | 86.7% | |
| Lowercase_Letter | 4 | 13.3% |
| Value | Count | Frequency (%) | |
| Latin | 30 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 30 | 100.0% |
market_segment
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 850.0 KiB |
| Online TA | |
|---|---|
| Offline TA/TO | |
| Groups | |
| Direct | |
| Corporate | 5079 |
| Other values (3) | 929 |
| Value | Count | Frequency (%) | |
| Online TA | 49545 | 45.5% | |
| Offline TA/TO | 22682 | 20.9% | |
| Groups | 19354 | 17.8% | |
| Direct | 11196 | 10.3% | |
| Corporate | 5079 | 4.7% | |
| Complementary | 697 | 0.6% | |
| Aviation | 230 | 0.2% | |
| Undefined | 2 | < 0.1% |
Length
| Max length | 13 |
|---|---|
| Mean length | 9.015038838 |
| Min length | 6 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 17 | 65.4% | |
| Uppercase_Letter | 7 | 26.9% | |
| Other_Punctuation | 1 | 3.8% | |
| Space_Separator | 1 | 3.8% |
| Value | Count | Frequency (%) | |
| Latin | 24 | 92.3% | |
| Common | 2 | 7.7% |
| Value | Count | Frequency (%) | |
| ASCII | 26 | 100.0% |
distribution_channel
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 850.0 KiB |
| TA/TO | |
|---|---|
| Direct | 13203 |
| Corporate | 6449 |
| GDS | 188 |
| Undefined | 5 |
| Value | Count | Frequency (%) | |
| TA/TO | 88940 | 81.8% | |
| Direct | 13203 | 12.1% | |
| Corporate | 6449 | 5.9% | |
| GDS | 188 | 0.2% | |
| Undefined | 5 | < 0.1% |
Length
| Max length | 9 |
|---|---|
| Mean length | 5.355223606 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 55.0% | |
| Uppercase_Letter | 8 | 40.0% | |
| Other_Punctuation | 1 | 5.0% |
| Value | Count | Frequency (%) | |
| Latin | 19 | 95.0% | |
| Common | 1 | 5.0% |
| Value | Count | Frequency (%) | |
| ASCII | 20 | 100.0% |
is_repeated_guest
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 850.0 KiB |
| 0 | |
|---|---|
| 1 | 3540 |
| Value | Count | Frequency (%) | |
| 0 | 105245 | 96.7% | |
| 1 | 3540 | 3.3% |
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.09440639794089259 |
|---|---|
| Minimum | 0 |
| Maximum | 26 |
| Zeros | 102366 |
| Zeros (%) | 94.1% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.8818788936 |
|---|---|
| Coefficient of variation (CV) | 9.341304327 |
| Kurtosis | 620.470582 |
| Mean | 0.09440639794 |
| Median Absolute Deviation (MAD) | 0.177671652 |
| Skewness | 23.5072585 |
| Sum | 10270 |
| Variance | 0.7777103829 |
| Value | Count | Frequency (%) | |
| 0 | 102366 | 94.1% | |
| 1 | 6008 | 5.5% | |
| 2 | 110 | 0.1% | |
| 3 | 62 | 0.1% | |
| 24 | 48 | < 0.1% | |
| 11 | 35 | < 0.1% | |
| 4 | 28 | < 0.1% | |
| 26 | 26 | < 0.1% | |
| 25 | 25 | < 0.1% | |
| 19 | 19 | < 0.1% | |
| Other values (5) | 58 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 102366 | 94.1% | |
| 1 | 6008 | 5.5% | |
| 2 | 110 | 0.1% | |
| 3 | 62 | 0.1% | |
| 4 | 28 | < 0.1% |
| Value | Count | Frequency (%) | |
| 26 | 26 | < 0.1% | |
| 25 | 25 | < 0.1% | |
| 24 | 48 | < 0.1% | |
| 21 | 1 | < 0.1% | |
| 19 | 19 | < 0.1% |
| Distinct count | 68 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.13695822034287816 |
|---|---|
| Minimum | 0 |
| Maximum | 67 |
| Zeros | 105388 |
| Zeros (%) | 96.9% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 67 |
| Range | 67 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.448224119 |
|---|---|
| Coefficient of variation (CV) | 10.57420369 |
| Kurtosis | 699.3621315 |
| Mean | 0.1369582203 |
| Median Absolute Deviation (MAD) | 0.2653629255 |
| Skewness | 22.49048645 |
| Sum | 14899 |
| Variance | 2.097353099 |
| Value | Count | Frequency (%) | |
| 0 | 105388 | 96.9% | |
| 1 | 1452 | 1.3% | |
| 2 | 549 | 0.5% | |
| 3 | 316 | 0.3% | |
| 4 | 223 | 0.2% | |
| 5 | 168 | 0.2% | |
| 6 | 104 | 0.1% | |
| 7 | 80 | 0.1% | |
| 8 | 65 | 0.1% | |
| 9 | 56 | 0.1% | |
| Other values (58) | 384 | 0.4% |
| Value | Count | Frequency (%) | |
| 0 | 105388 | 96.9% | |
| 1 | 1452 | 1.3% | |
| 2 | 549 | 0.5% | |
| 3 | 316 | 0.3% | |
| 4 | 223 | 0.2% |
| Value | Count | Frequency (%) | |
| 67 | 1 | < 0.1% | |
| 66 | 1 | < 0.1% | |
| 65 | 1 | < 0.1% | |
| 64 | 1 | < 0.1% | |
| 63 | 1 | < 0.1% |
reserved_room_type
Categorical
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 850.0 KiB |
| A | |
|---|---|
| D | |
| E | 5708 |
| F | 2536 |
| G | 1796 |
| Other values (4) | 2246 |
| Value | Count | Frequency (%) | |
| A | 79728 | 73.3% | |
| D | 16771 | 15.4% | |
| E | 5708 | 5.2% | |
| F | 2536 | 2.3% | |
| G | 1796 | 1.7% | |
| B | 1041 | 1.0% | |
| C | 689 | 0.6% | |
| H | 510 | 0.5% | |
| L | 6 | < 0.1% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 9 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 9 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 9 | 100.0% |
assigned_room_type
Categorical
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 850.0 KiB |
| A | |
|---|---|
| D | |
| E | 6967 |
| F | 3354 |
| G | 2226 |
| Other values (6) | 5244 |
| Value | Count | Frequency (%) | |
| A | 68162 | 62.7% | |
| D | 22832 | 21.0% | |
| E | 6967 | 6.4% | |
| F | 3354 | 3.1% | |
| G | 2226 | 2.0% | |
| C | 2068 | 1.9% | |
| B | 2068 | 1.9% | |
| H | 616 | 0.6% | |
| I | 327 | 0.3% | |
| K | 164 | 0.2% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 11 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 11 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 11 | 100.0% |
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.21174794319069726 |
|---|---|
| Minimum | 0 |
| Maximum | 18 |
| Zeros | 92781 |
| Zeros (%) | 85.3% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 18 |
| Range | 18 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6268624708 |
|---|---|
| Coefficient of variation (CV) | 2.960418228 |
| Kurtosis | 68.38416753 |
| Mean | 0.2117479432 |
| Median Absolute Deviation (MAD) | 0.3611929203 |
| Skewness | 5.662330433 |
| Sum | 23035 |
| Variance | 0.3929565573 |
| Value | Count | Frequency (%) | |
| 0 | 92781 | 85.3% | |
| 1 | 11397 | 10.5% | |
| 2 | 3285 | 3.0% | |
| 3 | 783 | 0.7% | |
| 4 | 317 | 0.3% | |
| 5 | 104 | 0.1% | |
| 6 | 55 | 0.1% | |
| 7 | 24 | < 0.1% | |
| 8 | 12 | < 0.1% | |
| 9 | 8 | < 0.1% | |
| Other values (8) | 19 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 92781 | 85.3% | |
| 1 | 11397 | 10.5% | |
| 2 | 3285 | 3.0% | |
| 3 | 783 | 0.7% | |
| 4 | 317 | 0.3% |
| Value | Count | Frequency (%) | |
| 18 | 1 | < 0.1% | |
| 17 | 2 | < 0.1% | |
| 16 | 2 | < 0.1% | |
| 15 | 3 | < 0.1% | |
| 14 | 3 | < 0.1% |
| Distinct count | 331 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 73.22889185089856 |
|---|---|
| Minimum | 0.0 |
| Maximum | 535.0 |
| Zeros | 15530 |
| Zeros (%) | 14.3% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6 |
| median | 9 |
| Q3 | 142 |
| 95-th percentile | 250 |
| Maximum | 535 |
| Range | 535 |
| Interquartile range (IQR) | 136 |
Descriptive statistics
| Standard deviation | 106.0426083 |
|---|---|
| Coefficient of variation (CV) | 1.448097952 |
| Kurtosis | 0.5632151831 |
| Mean | 73.22889185 |
| Median Absolute Deviation (MAD) | 89.24863688 |
| Skewness | 1.327094656 |
| Sum | 7966205 |
| Variance | 11245.03477 |
| Value | Count | Frequency (%) | |
| 9 | 28036 | 25.8% | |
| 0 | 15530 | 14.3% | |
| 240 | 12282 | 11.3% | |
| 1 | 7187 | 6.6% | |
| 7 | 3257 | 3.0% | |
| 14 | 3077 | 2.8% | |
| 6 | 2935 | 2.7% | |
| 250 | 2433 | 2.2% | |
| 28 | 1597 | 1.5% | |
| 241 | 1432 | 1.3% | |
| Other values (321) | 31019 | 28.5% |
| Value | Count | Frequency (%) | |
| 0 | 15530 | 14.3% | |
| 1 | 7187 | 6.6% | |
| 2 | 161 | 0.1% | |
| 3 | 1332 | 1.2% | |
| 4 | 47 | < 0.1% |
| Value | Count | Frequency (%) | |
| 535 | 3 | < 0.1% | |
| 531 | 30 | < 0.1% | |
| 527 | 35 | < 0.1% | |
| 526 | 5 | < 0.1% | |
| 510 | 2 | < 0.1% |
| Distinct count | 341 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.422411178011675 |
|---|---|
| Minimum | 0.0 |
| Maximum | 539.0 |
| Zeros | 102214 |
| Zeros (%) | 94.0% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 45 |
| Maximum | 539 |
| Range | 539 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 55.20809832 |
|---|---|
| Coefficient of variation (CV) | 4.833313865 |
| Kurtosis | 34.73977106 |
| Mean | 11.42241118 |
| Median Absolute Deviation (MAD) | 21.46675838 |
| Skewness | 5.688207478 |
| Sum | 1242587 |
| Variance | 3047.93412 |
| Value | Count | Frequency (%) | |
| 0 | 102214 | 94.0% | |
| 40 | 853 | 0.8% | |
| 223 | 784 | 0.7% | |
| 67 | 267 | 0.2% | |
| 45 | 239 | 0.2% | |
| 153 | 208 | 0.2% | |
| 174 | 147 | 0.1% | |
| 281 | 137 | 0.1% | |
| 219 | 132 | 0.1% | |
| 154 | 127 | 0.1% | |
| Other values (331) | 3677 | 3.4% |
| Value | Count | Frequency (%) | |
| 0 | 102214 | 94.0% | |
| 6 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 9 | 37 | < 0.1% | |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 539 | 1 | < 0.1% | |
| 534 | 2 | < 0.1% | |
| 530 | 4 | < 0.1% | |
| 528 | 1 | < 0.1% | |
| 525 | 6 | < 0.1% |
| Distinct count | 127 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.540249115227283 |
|---|---|
| Minimum | 0 |
| Maximum | 391 |
| Zeros | 105101 |
| Zeros (%) | 96.6% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 391 |
| Range | 391 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 18.40151145 |
|---|---|
| Coefficient of variation (CV) | 7.243979082 |
| Kurtosis | 170.5080725 |
| Mean | 2.540249115 |
| Median Absolute Deviation (MAD) | 4.908808498 |
| Skewness | 11.41503655 |
| Sum | 276341 |
| Variance | 338.6156238 |
| Value | Count | Frequency (%) | |
| 0 | 105101 | 96.6% | |
| 39 | 227 | 0.2% | |
| 58 | 164 | 0.2% | |
| 44 | 141 | 0.1% | |
| 31 | 127 | 0.1% | |
| 35 | 96 | 0.1% | |
| 46 | 94 | 0.1% | |
| 69 | 89 | 0.1% | |
| 63 | 83 | 0.1% | |
| 50 | 80 | 0.1% | |
| Other values (117) | 2583 | 2.4% |
| Value | Count | Frequency (%) | |
| 0 | 105101 | 96.6% | |
| 1 | 11 | < 0.1% | |
| 2 | 5 | < 0.1% | |
| 3 | 59 | 0.1% | |
| 4 | 25 | < 0.1% |
| Value | Count | Frequency (%) | |
| 391 | 45 | < 0.1% | |
| 379 | 15 | < 0.1% | |
| 330 | 15 | < 0.1% | |
| 259 | 10 | < 0.1% | |
| 236 | 35 | < 0.1% |
customer_type
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 850.0 KiB |
| Transient | |
|---|---|
| Transient-Party | |
| Contract | 3864 |
| Group | 524 |
| Value | Count | Frequency (%) | |
| Transient | 80589 | 74.1% | |
| Transient-Party | 23808 | 21.9% | |
| Contract | 3864 | 3.6% | |
| Group | 524 | 0.5% |
Length
| Max length | 15 |
|---|---|
| Mean length | 10.25833525 |
| Min length | 5 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 12 | 70.6% | |
| Uppercase_Letter | 4 | 23.5% | |
| Dash_Punctuation | 1 | 5.9% |
| Value | Count | Frequency (%) | |
| Latin | 16 | 94.1% | |
| Common | 1 | 5.9% |
| Value | Count | Frequency (%) | |
| ASCII | 17 | 100.0% |
| Distinct count | 7949 |
|---|---|
| Unique (%) | 7.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 97.08540727122305 |
|---|---|
| Minimum | -6.38 |
| Maximum | 5400.0 |
| Zeros | 1742 |
| Zeros (%) | 1.6% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | -6.38 |
|---|---|
| 5-th percentile | 37.83 |
| Q1 | 66.5 |
| median | 90 |
| Q3 | 120 |
| 95-th percentile | 178 |
| Maximum | 5400 |
| Range | 5406.38 |
| Interquartile range (IQR) | 53.5 |
Descriptive statistics
| Standard deviation | 46.91065887 |
|---|---|
| Coefficient of variation (CV) | 0.4831895976 |
| Kurtosis | 1502.090978 |
| Mean | 97.08540727 |
| Median Absolute Deviation (MAD) | 33.40646664 |
| Skewness | 14.04442566 |
| Sum | 10561436.03 |
| Variance | 2200.609916 |
| Value | Count | Frequency (%) | |
| 62 | 3754 | 3.5% | |
| 75 | 2701 | 2.5% | |
| 65 | 2369 | 2.2% | |
| 90 | 2336 | 2.1% | |
| 80 | 1826 | 1.7% | |
| 0 | 1742 | 1.6% | |
| 95 | 1617 | 1.5% | |
| 100 | 1556 | 1.4% | |
| 85 | 1525 | 1.4% | |
| 120 | 1481 | 1.4% | |
| Other values (7939) | 87878 | 80.8% |
| Value | Count | Frequency (%) | |
| -6.38 | 1 | < 0.1% | |
| 0 | 1742 | 1.6% | |
| 0.26 | 1 | < 0.1% | |
| 0.5 | 1 | < 0.1% | |
| 1 | 14 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5400 | 1 | < 0.1% | |
| 510 | 1 | < 0.1% | |
| 508 | 1 | < 0.1% | |
| 451.5 | 1 | < 0.1% | |
| 384 | 1 | < 0.1% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.06309693431998897 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros | 101966 |
| Zeros (%) | 93.7% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2465175647 |
|---|---|
| Coefficient of variation (CV) | 3.906965804 |
| Kurtosis | 31.21274107 |
| Mean | 0.06309693432 |
| Median Absolute Deviation (MAD) | 0.1182836238 |
| Skewness | 4.181996672 |
| Sum | 6864 |
| Variance | 0.06077090972 |
| Value | Count | Frequency (%) | |
| 0 | 101966 | 93.7% | |
| 1 | 6789 | 6.2% | |
| 2 | 25 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 8 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 101966 | 93.7% | |
| 1 | 6789 | 6.2% | |
| 2 | 25 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 8 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 8 | 2 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 2 | 25 | < 0.1% | |
| 1 | 6789 | 6.2% | |
| 0 | 101966 | 93.7% |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5442386358413385 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros | 65912 |
| Zeros (%) | 60.6% |
| Memory size | 850.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.7771496217 |
|---|---|
| Coefficient of variation (CV) | 1.427957463 |
| Kurtosis | 1.588764744 |
| Mean | 0.5442386358 |
| Median Absolute Deviation (MAD) | 0.6595000591 |
| Skewness | 1.390769741 |
| Sum | 59205 |
| Variance | 0.6039615345 |
| Value | Count | Frequency (%) | |
| 0 | 65912 | 60.6% | |
| 1 | 29218 | 26.9% | |
| 2 | 11295 | 10.4% | |
| 3 | 2076 | 1.9% | |
| 4 | 251 | 0.2% | |
| 5 | 33 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 65912 | 60.6% | |
| 1 | 29218 | 26.9% | |
| 2 | 11295 | 10.4% | |
| 3 | 2076 | 1.9% | |
| 4 | 251 | 0.2% |
| Value | Count | Frequency (%) | |
| 5 | 33 | < 0.1% | |
| 4 | 251 | 0.2% | |
| 3 | 2076 | 1.9% | |
| 2 | 11295 | 10.4% | |
| 1 | 29218 | 26.9% |
| Distinct count | 730 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 850.0 KiB |
| 2015-12-05 | 448 |
|---|---|
| 2016-11-07 | 365 |
| 2015-10-16 | 355 |
| 2016-10-13 | 344 |
| 2015-09-18 | 340 |
| Other values (725) |
| Value | Count | Frequency (%) | |
| 2015-12-05 | 448 | 0.4% | |
| 2016-11-07 | 365 | 0.3% | |
| 2015-10-16 | 355 | 0.3% | |
| 2016-10-13 | 344 | 0.3% | |
| 2015-09-18 | 340 | 0.3% | |
| 2017-06-08 | 337 | 0.3% | |
| 2017-03-02 | 335 | 0.3% | |
| 2016-10-28 | 332 | 0.3% | |
| 2015-09-17 | 331 | 0.3% | |
| 2017-04-29 | 330 | 0.3% | |
| Other values (720) | 105268 | 96.8% |
Length
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 90.9% | |
| Dash_Punctuation | 1 | 9.1% |
| Value | Count | Frequency (%) | |
| Common | 11 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 11 | 100.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
First rows
| id | hotel | is_canceled | lead_time | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | agent | company | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | arrival_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | Resort Hotel | 0 | 1 | 0 | 1 | 2 | 0.0 | 1 | BB | PRT | Direct | Direct | 0 | 0 | 0 | A | A | 1 | 250.0 | 0.0 | 0 | Transient | 55.00 | 1 | 0 | 2017-02-04 |
| 1 | 2 | Resort Hotel | 0 | 1 | 0 | 2 | 1 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | A | D | 0 | 0.0 | 0.0 | 0 | Transient | 40.00 | 0 | 0 | 2016-03-04 |
| 2 | 3 | City Hotel | 1 | 56 | 0 | 3 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | 29.0 | 0.0 | 0 | Transient | 60.00 | 0 | 0 | 2017-02-01 |
| 3 | 4 | City Hotel | 0 | 213 | 2 | 5 | 2 | 0.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | 9.0 | 0.0 | 0 | Transient | 102.85 | 0 | 1 | 2016-10-05 |
| 4 | 5 | Resort Hotel | 0 | 328 | 4 | 10 | 2 | 0.0 | 0 | BB | GBR | Offline TA/TO | TA/TO | 0 | 0 | 0 | D | D | 0 | 243.0 | 0.0 | 0 | Contract | 121.50 | 0 | 2 | 2017-06-29 |
| 5 | 6 | Resort Hotel | 0 | 57 | 2 | 4 | 2 | 0.0 | 0 | BB | GBR | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | 26.0 | 0.0 | 0 | Transient | 39.10 | 0 | 0 | 2016-04-07 |
| 6 | 7 | City Hotel | 1 | 44 | 2 | 3 | 2 | 0.0 | 0 | BB | NLD | Online TA | TA/TO | 0 | 0 | 0 | D | D | 2 | 9.0 | 0.0 | 0 | Transient | 113.52 | 0 | 0 | 2016-04-10 |
| 7 | 8 | Resort Hotel | 0 | 0 | 1 | 0 | 2 | 0.0 | 0 | HB | NLD | Direct | Direct | 0 | 0 | 0 | E | E | 1 | 0.0 | 0.0 | 0 | Transient | 84.00 | 0 | 0 | 2016-03-27 |
| 8 | 9 | Resort Hotel | 0 | 4 | 1 | 4 | 2 | 0.0 | 0 | BB | ESP | Offline TA/TO | TA/TO | 0 | 0 | 0 | C | C | 0 | 142.0 | 0.0 | 0 | Transient | 102.24 | 1 | 0 | 2015-09-14 |
| 9 | 10 | Resort Hotel | 0 | 40 | 1 | 2 | 1 | 0.0 | 0 | SC | PRT | Groups | Direct | 0 | 0 | 0 | A | A | 0 | 0.0 | 0.0 | 0 | Transient-Party | 55.00 | 0 | 0 | 2017-01-16 |
Last rows
| id | hotel | is_canceled | lead_time | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | agent | company | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | arrival_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 108775 | 108776 | City Hotel | 1 | 65 | 2 | 3 | 2 | 0.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | 9.0 | 0.0 | 0 | Transient | 73.95 | 0 | 2 | 2016-03-03 |
| 108776 | 108777 | City Hotel | 0 | 60 | 1 | 0 | 3 | 0.0 | 0 | BB | DEU | Online TA | TA/TO | 0 | 0 | 0 | D | E | 0 | 9.0 | 0.0 | 0 | Transient | 137.70 | 0 | 2 | 2016-07-25 |
| 108777 | 108778 | City Hotel | 1 | 30 | 2 | 1 | 2 | 0.0 | 0 | HB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | 1.0 | 0.0 | 0 | Transient-Party | 86.00 | 0 | 0 | 2015-08-08 |
| 108778 | 108779 | City Hotel | 0 | 95 | 1 | 2 | 2 | 0.0 | 0 | BB | DEU | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | 168.0 | 0.0 | 0 | Transient | 80.75 | 0 | 0 | 2016-05-06 |
| 108779 | 108780 | Resort Hotel | 1 | 102 | 2 | 5 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | 240.0 | 0.0 | 0 | Transient | 80.00 | 0 | 0 | 2016-05-31 |
| 108780 | 108781 | City Hotel | 1 | 37 | 0 | 3 | 2 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | 56.0 | 0.0 | 0 | Transient-Party | 105.00 | 0 | 0 | 2016-10-13 |
| 108781 | 108782 | City Hotel | 0 | 13 | 1 | 2 | 2 | 0.0 | 0 | BB | FRA | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | 28.0 | 0.0 | 0 | Transient | 82.00 | 0 | 0 | 2016-01-11 |
| 108782 | 108783 | City Hotel | 0 | 124 | 0 | 3 | 2 | 0.0 | 0 | BB | FRA | Online TA | TA/TO | 0 | 0 | 0 | A | A | 2 | 9.0 | 0.0 | 0 | Transient | 126.00 | 0 | 1 | 2017-04-18 |
| 108783 | 108784 | Resort Hotel | 1 | 130 | 2 | 5 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | 240.0 | 0.0 | 0 | Transient | 120.60 | 0 | 2 | 2015-08-01 |
| 108784 | 108785 | Resort Hotel | 0 | 174 | 2 | 5 | 2 | 0.0 | 0 | HB | GBR | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | 243.0 | 0.0 | 0 | Contract | 58.23 | 0 | 0 | 2015-09-24 |